Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by yangbing1008

  1. yangbing1008

    Get data from two different database

    table1: col1,col2 and col3 from Database1. Table2:col4,col5 and col6 from Database2. When I was using equal inner, I got no record. After I used left outer join, I got records and all values from col1, col2 but any values from col4, col5. I want list col1, col2, co4, col5 in my report. (BTW, I...
  2. yangbing1008

    Get data from two different database

    RobbieB: I was happy too early. I got records from DB2 but column value didn't show up. eg. col4, col5 value is empty. Do you have this problem? Thanks a lot.
  3. yangbing1008

    Get data from two different database

    RobbieB: You are right. Left outer join works. But why inner join doesn't work. Thanks.
  4. yangbing1008

    Get data from two different database

    Do you have any more comments?
  5. yangbing1008

    Get data from two different database

    Thanks both of you. I used database export to create links, it showed warning "more than one datasource or store procedure has been used in this report. please make sure that no SQL expression added or no server-side group-by performed". When I run report, no errors but got nothing. Check SQL...
  6. yangbing1008

    Get data from two different database

    Both are Oracle database. I created links between two tables from different database. It looks fine. I run my report and I got nothing. I checked SQL in CR and it showed two separate queries not a join query between two tables.
  7. yangbing1008

    Get data from two different database

    I am trying to retrieve data from two tables which are from two datasources (db1 & db2)and some columns need to be joined from these two tables. eg, table1: col1,col2,col3 table2:col4,col5,col6, I need col1,col2,col4,col5 where col3=col6. Do anyone know how to implement it in CRXI?
See more

Part and Inventory Search

Back
Top