silly question.. but how do I give you the DDL?

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.

Jeff...

thank you for your reply, i will take a look at the data warehouse version as well.

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...

so you mean both options will produce the same result? It doesn't matter?

thank you for the reply, so basically the answer is yes you can join PK to PK and FK to FK.

cphite (3/11/2016)

---

wallywizard (3/11/2016)

---

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...

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...

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...

thanks jeff, I used w3schools but that seems too basic. I am looking for a book format that has more pages to learn from.

thank you

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...

Jeff Moden (8/19/2015)

---

If you're serious about learning SQL Server, stop farting around with the free stuff and by the Developer's Edition for about $60USD. People bitch about the price...

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...

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?