Page 1 of 1

Select * question

Posted: Mon Jul 31, 2006 10:03 am
by Benjamin
Is it possible to write a query which contains joins, that would select * from 1 table, and only specific fields from other tables?

Posted: Mon Jul 31, 2006 10:06 am
by volka
yes

Code: Select all

select
      a.*,
      b.xyz
FROM
    tableA as a
JOIN
    tableB as b
ON
  a.id=b.id

Posted: Mon Jul 31, 2006 10:07 am
by RobertGonzalez
Yes.

Code: Select all

SELECT t.*, r.ride_id FROM time_table t INNER JOIN ride_table r ON t.ride_id = t.ride_id;

Posted: Mon Jul 31, 2006 10:09 am
by Benjamin
Ok great, thanks guys.