Retrieving data from another table with a given ID

Zarathu · #1 (**permalink**) 11-17-06, 18:43

http://i9.tinypic.com/2ynoyva.png

[Note: Ignore the duplicates, I was being careless.]

I want to know which command I would use, giving it "54352345" and have it return "FDSA."

shammat · #2 (**permalink**) 11-17-06, 19:11

SELECT column_2
FROM the_table
WHERE column_1 = 54352345

Zarathu · #3 (**permalink**) 11-18-06, 01:07

Excellent. If the given ID was nowhere to be found in column_1, what would it return? Null?

shammat · #4 (**permalink**) 11-18-06, 04:34

It would return no rows at all

Don't understand me wrong: but before doing any further work you should read a good tutorial on database concepts and the SQL language

healdem · #5 (**permalink**) 11-18-06, 06:27

Quote:

Originally Posted by shammat

It would return no rows at all

Don't understand me wrong: but before doing any further work you should read a good tutorial on database concepts and the SQL language

..good point, well made, Rudy's (r937) site has a good article from Paul Litwin that might be of interest

Internet Services

Web Development

Digital Marketing

Consumer Tech