Sql Looping Logic?

Results 1 to 2 of 2

Thread: Sql Looping Logic?

  1. #1
    Join Date
    Dec 1969

    Default Sql Looping Logic?

    I want to perform a sql query in the following manner:<BR><BR>1.) (SELECT RowX, RowY, RowZ from tblA) // Returns set of rows (A)<BR>2.) for each RowX in (A)<BR> (SELECT RowA, RowB, RowC from tblB Where RowA = tblA.RowX)<BR><BR>How does one achieve this in tSQL?

  2. #2
    Join Date
    Dec 1969

    Default RE: Sql Looping Logic?

    SELECT RowA, RowB, RowC,RowX, RowY, RowZ<BR> from tblB,tbla <BR>Where tblb.RowA = tblA.RowX

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts