Re: same record multiple tables

Hi Clive,

you should use table aliasses (Is this the right spelling?)!

If a the same column name exists in different tables that you join, then there must be a reference, what column you mean. There are two possibilities:
1) Full-quoting:

    select table_a.id

           , table_b.name
    from table_a

           , table_b
    where table_a.id = table_b.id;
2) Using Alias:

   select a.id

, b.name

    from table_a a

, table_b b

    where a.id = b.id;

HTH

-- 
Reinhard
--------------------------------------------------------------
For direct reply please remove _nospam from address