Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Help

Status
Not open for further replies.

jrprogr

Programmer
Jul 20, 2006
74
US
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
 
What links a record from table1 to table2?

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
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.
 
I have problem in the designing the tables......I had posted the issue in new post..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top