select statements with SQL

Question

Is it possible to use select * for only one table when using a join statement?

Let's say these are the following tables;

B
userID
username

A
userID
entry 
....just pretend there are more columns for the sake of this example

What is the correct way to look up the username from table B?

select B.username, * from A
LEFT JOIN B on B.userID = A.userID
where A.entry = "XXXXX"

Or do I have to list out everything I want to select such as:

select B.username, A.userID, A.entry from A
left Join.....

What happens when you try it? You'd have had an answer a lot faster than asking here, and you might learn something useful in the process. :) — Ken White
– Ken White, Commented Apr 24, 2012 at 23:48

user1104854 · Accepted Answer · 2012-04-25 03:14:19Z

3

You can use [table name].* to select all fields from one of the tables. For example, to select all fields from table B use:

 SELECT B.*, username FROM A
 LEFT JOIN B on B.userID = A.userID
 WHERE A.entry = "XXXXX"

edit - selected column username from A

user1104854

2,17714 gold badges53 silver badges76 bronze badges

answered Apr 24, 2012 at 23:44

BluesRockAddict

15.6k3 gold badges40 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks, yours worked. I had to add username and then it worked perfectly.

0b10011 · Accepted Answer · 2012-04-24 23:44:55Z

1

SELECT A.* FROM ... where A is the table you want to select from.

answered Apr 24, 2012 at 23:44

0b10011

18.9k4 gold badges69 silver badges90 bronze badges