Select * and column in different tables.

Question

question

wash4 asked Jan 20, '13

Select * and column in different tables.

Hello, I would like to ask, is there a way, how to join two tables ( from first I need all columns (around 80) and second I need just two columns)? One way is to write each record (column) I need but it is realy boring 80 columns..

select joins columns

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2013-01-20T16:04:46Z

Kev Riley answered Jan 20, '13

Whilst it is not best practice to use `select *`, you can specify which tables select a.*, b.col1, b.col2 from TableA a join TableB b on a.id= b.id will give you all the columns from the first table, but only those you've specified from the second.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

wash4 commented · Jan 20, 2013 at 08:48 PM

Super thanks! It is working!

0 ·

Answer 2 · 2013-01-20T16:28:44Z

ThomasRushton answered Jan 20, '13

ISTR that, if you drag the table from SSMS's object explorer into a query window it writes out a list of all columns. I could, of course, be wrong. It's Sunday, and I've not got a SQL Server fired up to play with.

4

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack ♦♦ commented · Jan 20, 2013 at 06:46 PM

ISTR >> I seem to recall +1 - even though you don't have SQL Server running. Sunday is no excuse!

1 ·

askmlx121 commented · Jan 21, 2013 at 01:09 PM

hi fatherjack and thomasrushton experts dont be fight ....in words.....come with solution

1 ·

ThomasRushton ♦♦ commented · Jan 21, 2013 at 09:35 AM

Is "answering questions from the phone" a better excuse?

0 ·

Fatherjack ♦♦ commented · Jan 21, 2013 at 09:37 AM

ah, that would be acceptable.

0 ·

question