Extracting data

[Prayder]

I have a table that has information I am wanting to get in a query. One of the columns is equipment and I am wanting to query just the forklifts which are labeled g-k-1 through g-k-9. How would i get the info for just this equipment and not all of it?

 

[pr2-eugin]

Not following you there.. Should it not be a simple Query?

SELECT theTableName.* FROM theTableName
WHERE forkLiftColumn = 'g-k-1';

 

[Prayder]

in the equipment column we have a bunch of different equipment called different things. the nomenclature for the forklifts follows as g-k-1, g-k-2, g-k-3, etc and also as g-t-7, g-t-8 etc. so I am trying to figure out a way to just get the forklift names and not all the rest of the equipment.

 

[pr2-eugin]

How about creating a Table,

tblEquipments
equipmentID
equipmentType

So the data would be something like..

equipmentID    equipmentType
1                    Forklift
2                    Trolley

So your actual table should look like..

someID    equipmentID_FK    someData
1                1            Relationship is important
2                1            in an RDBM System.
3                2            Lookup Normalization.

So when Querying the DB, you will be doing something as simple as I have shown, but replacing it with equipmentID..

 

[Prayder]

Thanks man... I completely forgot about doing the relationships.. You were a huge help....... I sincerely appreciate it..

 

[David R]

Paul, that was the sneakiest educational moment I've seen in a long time...

 

[pr2-eugin]

Paul, that was the sneakiest educational moment I've seen in a long time...

LOL ! Did not mean to sound like a condescending J3RK ! But I have to admit, something is wrong with me today !

 

[David R]

Nah, I thought it was great. I'm going to remember that in future 'dummy data'.