Hello all, I was wondering how do to something. I have a table that I need to do some kind of sub query. I am learning so this query eill teach me a lot. I have 2 columns One is the ID and the other is Num. I need to search for all Nums that have a "0" in it and get the ID of that row. I then need to search in the column "Num" and get match the row id. I think this would be an embedded search (something like that).
Here is my columns.
ID Num 2 0 3 2 4 2
I will attempt the query string:
select Num from table where Num = (select ID from Num where Num = 0 )
Something like that. I want to learn how to do this kind of search.
-How important does a person have to be before they are considered assassinated instead of just murdered? Congratulations!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.