Query Help

[jrprogr]

Please help in writing the query to get the output.

Table1:

Fld1 Fld2 Fld3 Fld4
----------------------------------------------
1 1988 5487 2004-08-05 00:00:00.000
1 1988 5675 2006-08-05 00:00:00.000


Table2:

Fld1 Fld2 Fld3
--------------------
2 1988 256
2 1988 250



Output:

Fld1 Fld2 Fld3 Fld4 Fld1 Fld2 Fld3
--------------------------------------------------------------------
1 1988 5487 2004-08-05 00:00:00.000 2 1988 256
1 1988 5675 2006-08-05 00:00:00.000 2 1988 250

 

[gmmastros]

What links a record from table1 to table2?

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

please provide DDL and DML Insert statements

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[vonehle]

I believe you'll want a SELECT INTO statement to accomplish this.

I'm pretty sure most people on this forum prefer you to post the code you've tried. Partly because if this is homework, they'd like to know you've tried it yourself, and not just trying to get others to do your homework for you. There are many that are perfectly happy to help, as long as you show you're making the effort.

 

[jrprogr]

I have problem in the designing the tables......I had posted the issue in new post..