Viewing 15 posts - 1 through 15 (of 21 total)
silly question.. but how do I give you the DDL?
November 13, 2020 at 1:59 pm
thanks everyone...you all had great answers. equi-join is exactly what I was looking for. I will do more research on it.
FYI, thats not my code. Its actually from techonthenet site.
March 6, 2020 at 1:57 am
thank you for your reply, i will take a look at the data warehouse version as well.
February 20, 2020 at 1:52 pm
Thank you, but I'd like learn why min isnt working. Do you know why? I find i strange. I know there are other ways of doing it. But this is...
November 4, 2019 at 4:08 pm
Which is better?
March 7, 2019 at 5:13 pm
so you mean both options will produce the same result? It doesn't matter?
March 6, 2019 at 6:38 pm
thank you for the reply, so basically the answer is yes you can join PK to PK and FK to FK.
March 2, 2019 at 11:08 am
There are tons of items, I am only looking to pull...
March 14, 2016 at 7:33 am
sorry let me rephrase....I dont have an item that ends both S and B at the same time.
There are tons of items, I am only looking to pull items that...
March 11, 2016 at 2:13 pm
yes that worked! thanks...
1. Why would OR work? OR sounds like I need only either S or B, but in reality I need BOTH. Strange...
2. Is there a way...
March 11, 2016 at 1:06 pm
thanks jeff, I used w3schools but that seems too basic. I am looking for a book format that has more pages to learn from.
December 3, 2015 at 1:54 pm
thanks for that info, i should be fine with express because i only want it to learn queries. I wont be doing database replications etc... just simple queries and joins...
August 20, 2015 at 9:02 am
Jeff Moden (8/19/2015)
August 20, 2015 at 6:10 am
Thank you for the link, I was on that site but confused on what to get. I see all these versions. Can you please point out what I exactly...
August 19, 2015 at 1:58 pm
I read about using the REPLACE command with char(13) AND char(10), but I dont know how to use this. Can anyone please help me?
June 25, 2015 at 1:59 pm