is this possible in anyway

[sabret00the]

SELECT UNIQUE shared-id
FROM table
and then use a while to make it print out the results?

basically i just want to check two different tables to see is theirs a record in each for each shared-id.

[Xenon]

it's called SELECT DISTINCT ;)

[sabret00the]

thank you, i knew it had to in there somewhere :)

[Xenon]

you're welcome :)