i want to write a optimal query for a complex problem
-
Hi to all How can I write a query that get me this result: My table is : ColumnA ColumnB ColumnC ColumnD A1 B1 Can be any thing Can be any thing A1 B2 Can be any thing Can be any thing A1 0 Can be any thing Can be any thing A1 0 Can be any thing Can be any thing A3 1 Can be any thing Can be any thing I want to get this result after run a query: ColumnA ColumnB ColumnC ColumnD A1 B1 Can be any thing Can be any thing A1 0 Can be any thing Can be any thing A1 0 Can be any thing Can be any thing A3 1 Can be any thing Can be any thing If ColumnA have B1 and also have a row with B2 I want to just get A1 B1 Row How can I do this Thanks for any idea
-
Hi to all How can I write a query that get me this result: My table is : ColumnA ColumnB ColumnC ColumnD A1 B1 Can be any thing Can be any thing A1 B2 Can be any thing Can be any thing A1 0 Can be any thing Can be any thing A1 0 Can be any thing Can be any thing A3 1 Can be any thing Can be any thing I want to get this result after run a query: ColumnA ColumnB ColumnC ColumnD A1 B1 Can be any thing Can be any thing A1 0 Can be any thing Can be any thing A1 0 Can be any thing Can be any thing A3 1 Can be any thing Can be any thing If ColumnA have B1 and also have a row with B2 I want to just get A1 B1 Row How can I do this Thanks for any idea
How should the query behave if you have a row with B2 but none with B1? Should the row with B2 be included or not?
Wrong is evil and must be defeated. - Jeff Ello[^]