I have queries that join several tables. Instead of having to know the specific PRIMARY keys for each table, is there a way i can reference them and the SQL server will know what I want?
Example:
PHP Code:
SELECT tld.PRIMARY as index, tld.id as id, rcx.user as user FROM...
Is there something I could use in place of 'tld.PRIMARY' that would make the database understand I want to use whatever that table has for a PRIMARY key? |
