Select * question
Posted: Mon Jul 31, 2006 10:03 am
Is it possible to write a query which contains joins, that would select * from 1 table, and only specific fields from other tables?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
select
a.*,
b.xyz
FROM
tableA as a
JOIN
tableB as b
ON
a.id=b.idCode: Select all
SELECT t.*, r.ride_id FROM time_table t INNER JOIN ride_table r ON t.ride_id = t.ride_id;