E.G. Query with two Tables Joined Fails

Reply
Contributor
Posts: 42

E.G. Query with two Tables Joined Fails

I have two tables that I have joined and have attempted to run a query.

It's an Inner-Join with two similar fields joined.

Each time I run it it fails.

Any suggestions?


Super Contributor
Posts: 1,636

Re: E.G. Query with two Tables Joined Fails

Make sure the fields have same data type.

Contributor
Posts: 42

Re: E.G. Query with two Tables Joined Fails

They do.

Super Contributor
Posts: 1,636

Re: E.G. Query with two Tables Joined Fails

What do you mean by "failed"?

do you want to post your log file?

Contributor
Posts: 42

Re: E.G. Query with two Tables Joined Fails

I finally got the join to work and successfully output a joined data set.

I just used two fields that associated in both tables.

Not sure why the other fields I used didn't work.

Any clues and thanks for your quick response.

Super User
Posts: 11,343

Re: E.G. Query with two Tables Joined Fails

It is  hard to diagnose code issues without code.

Ask a Question
Discussion stats
  • 5 replies
  • 234 views
  • 3 likes
  • 3 in conversation