You're going to want something like this.

SELECT m.column_name, t.column_name

FROM App_Main m

INNER JOIN App_Test t ON m.eai_code = t.[EAI Code]

ORDER BY m.column_name;

Luis Cazares (10/30/2013)

---

There might be, but it might take me a...

You know, speaking of "death by porkchop" I admit I'm curious about that spud gun I read about...

jcb (10/29/2013)

---

Thanks for everyone take time to write a comment.

Things are a bit worse:

1. The guys enforced this police are the architects/bosses/co owners of the corporation, to steps above me...

Stefan Krzywicki (10/29/2013)

---

Sean Lange (10/29/2013)

---

Ed Wagner (10/29/2013)

---

Sean Lange (10/29/2013)

---

Chad Crawford (10/29/2013)

---

We use the scale of 1-10 to help give us an idea of how tough to start the interview...

The transaction log is the log for an entire database. Anything the changes the data in the tables (insert, update, delete, bulk insert, alter index, etc.) will generate log...

Sean Lange (10/29/2013)

---

Chad Crawford (10/29/2013)

---

We use the scale of 1-10 to help give us an idea of how tough to start the interview questions, but we usually give the...

Luis Cazares (10/29/2013)

---

If you're looking for ideas, this phrase by Jeff Moden might help you.

First step towards the paradigm shift of writing Set Based code:

Stop thinking about what you...

As for the GUIDs, I was fortunately enough to attend a seminar on keys by Kimberly Tripp once and she said that she uses a few criteria when looking for...

Sean Lange (10/28/2013)

---

Luis Cazares (10/28/2013)

---

Rating someone on an average for all SQL Server is not a great idea. I could rate myself high on developing T-SQL, but not on DBA...

GilaMonster (10/28/2013)

---

Apparently the current top database guy at the company I'm joining is ecstatic about my joining them. From what I heard from one of the other devs, he has...

I like the analogy of the piles of knowledge. I'm in a similar situation where I consider myself good at what I do (Pile A), but I always want...

SQL Saturday

Well, going back to what Koen said, read the...

shahi.alokchandra (10/25/2013)

---

I am doing same. i am deleting an entry for which there is no row in its child table or in referencing table,though i am getting same error.

The query...