Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM TableA
- JOIN
- (SELECT DISTINCT IdA FROM TableB WHERE Date = '20090110') a
- ON a.IDA = TAbleA.IDA
- ORDER BY TableA.IdA
- SELECT *
- FROM TableA A
- WHERE Exists( select B.IdA from TableB B where A.IdA = B.IdA and B.Date = '2009-01-10' )
- ORDER BY A.Id;
- Select TableA.*, groupedTableB.OtherData
- From TableA
- Inner join
- (
- select TableB.IdA, Sum(TableB.Data) SummaryData
- from TableB where TableB.Date = '2009-01-10'
- group by TableB.IdA
- ) groupedTableB on groupedTableB.IdA = TableA.IdA
- distinct
- distinct
Add Comment
Please, Sign In to add comment