topic E.G. Query with two Tables Joined Fails in SAS Programming https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80744#M256618 <HTML><HEAD></HEAD><BODY><P>I have two tables that I have joined and have attempted to run a query.</P><P></P><P>It's an Inner-Join with two similar fields joined.</P><P></P><P>Each time I run it it fails.</P><P></P><P>Any suggestions?</P><P></P><P><BR /> </P></BODY></HTML> Thu, 12 Sep 2013 20:21:54 GMT BillB 2013-09-12T20:21:54Z E.G. Query with two Tables Joined Fails https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80744#M256618 <HTML><HEAD></HEAD><BODY><P>I have two tables that I have joined and have attempted to run a query.</P><P></P><P>It's an Inner-Join with two similar fields joined.</P><P></P><P>Each time I run it it fails.</P><P></P><P>Any suggestions?</P><P></P><P><BR /> </P></BODY></HTML> Thu, 12 Sep 2013 20:21:54 GMT https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80744#M256618 BillB 2013-09-12T20:21:54Z Re: E.G. Query with two Tables Joined Fails https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80745#M256619 <HTML><HEAD></HEAD><BODY><P>Make sure the fields have same data type.</P></BODY></HTML> Thu, 12 Sep 2013 20:33:57 GMT https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80745#M256619 Linlin 2013-09-12T20:33:57Z Re: E.G. Query with two Tables Joined Fails https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80746#M256620 <HTML><HEAD></HEAD><BODY><P>They do.</P></BODY></HTML> Thu, 12 Sep 2013 20:37:20 GMT https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80746#M256620 BillB 2013-09-12T20:37:20Z Re: E.G. Query with two Tables Joined Fails https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80747#M256621 <HTML><HEAD></HEAD><BODY><P>What do you mean by "failed"?</P><P>do you want to post your log file?</P></BODY></HTML> Thu, 12 Sep 2013 20:46:26 GMT https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80747#M256621 Linlin 2013-09-12T20:46:26Z Re: E.G. Query with two Tables Joined Fails https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80748#M256622 <HTML><HEAD></HEAD><BODY><P>I finally got the join to work and successfully output a joined data set.</P><P></P><P>I just used two fields that associated in both tables.</P><P></P><P>Not sure why the other fields I used didn't work.</P><P></P><P>Any clues and thanks for your quick response.</P></BODY></HTML> Fri, 13 Sep 2013 11:59:39 GMT https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80748#M256622 BillB 2013-09-13T11:59:39Z Re: E.G. Query with two Tables Joined Fails https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80749#M256623 <HTML><HEAD></HEAD><BODY><P>It is&nbsp; hard to diagnose code issues without code.</P></BODY></HTML> Fri, 13 Sep 2013 18:23:48 GMT https://communities.sas.com/t5/SAS-Programming/E-G-Query-with-two-Tables-Joined-Fails/m-p/80749#M256623 ballardw 2013-09-13T18:23:48Z