Gossamer Forum: General: Databases and SQL: Grabbing value from a different table, based on results from current table...

Jan 6, 2005, 8:52 AM

Andy

Veteran / Moderator (18441 posts)

Jan 6, 2005, 8:52 AM

Post #1 of 3

Shortcut

Grabbing value from a different table, based on results from current table...

Hi guys, I'm trying to do something like;

SELECT pmtext.pmid FROM pm WHERE pm.userid = 3312

.. but its giving me an error.

Basically, I just want to select pmtext.pmid, based on the results for "WHERE pm.userid = ...".

Anyone got any ideas? My head is really hurting today Frown

TIA

Andy (mod)
andy@ultranerds.co.uk

Jan 6, 2005, 2:36 PM

Alex

Administrator (9387 posts)

Jan 6, 2005, 2:36 PM

Post #2 of 3

Shortcut

Re: [Andy] Grabbing value from a different table, based on results from current table... In reply to

Hi,

You need to join the tables:

select pmtext.pmid
from pm, pmtext
where pm.a = pmtext.b and
pm.userid = '....';

You need to look at how the tables are joined, and fill in the a and b. =)

Cheers,

Alex
--
Gossamer Threads Inc.

Jan 6, 2005, 11:32 PM

Andy

Veteran / Moderator (18441 posts)

Jan 6, 2005, 11:32 PM

Post #3 of 3

Shortcut

Re: [Alex] Grabbing value from a different table, based on results from current table... In reply to

Thanks... worked a charm :)

Cheers

Andy (mod)
andy@ultranerds.co.uk