Select * question
Moderator: General Moderators
Select * question
Is it possible to write a query which contains joins, that would select * from 1 table, and only specific fields from other tables?
yes
Code: Select all
select
a.*,
b.xyz
FROM
tableA as a
JOIN
tableB as b
ON
a.id=b.id- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
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;