Basic query

[Mcnultyj]

Hello,

I need to write a basic query to only show the columns that belong to a particular row not all the rows in the table. for example all the columns that belong to id4.

regards

 

[THoey]

I think you are either loking for:

SELECT *
FROM MyTable
WHERE MyTable.ID = "ID4"

Or:

SELECT ID4
FROM MyTable

Not sure, but one of those should do... Terry M. Hoey