Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Using the LEFT function to concatenate tables?

I'm doing the load a table of my Sybase database and a table from a csv file, I need to join the two and so I know I should use the concatenate function (append queries) however as I apply the left function at this juncture of the two tables?

Need Help
  • sornavoor's avatar
    sornavoor
    10 years ago

    Question  not clear - Do you just need to a left join between a) Sysbase tables  & csv file table or b) do you need to append csv table to your  sybase table. 

     

    If a)  Then used the Relationships tab (or Manage Relationships) and set the required relationships

    If b) use the  "Append  Queries"  when loading the data

     

    Regards. 

2 Replies

  • sornavoor's avatar
    sornavoor
    Resolver I
    10 years ago

    Question  not clear - Do you just need to a left join between a) Sysbase tables  & csv file table or b) do you need to append csv table to your  sybase table. 

     

    If a)  Then used the Relationships tab (or Manage Relationships) and set the required relationships

    If b) use the  "Append  Queries"  when loading the data

     

    Regards. 

  • Vicky_Song's avatar
    Vicky_Song
    Impactful Individual
    10 years ago
    I need to join the two and so I know I should use the concatenate function (append queries) however as I apply the left function at this juncture of the two tables?

    I'm not quite clear of your question. Especially "however as I apply the left function at this juncture of the two tables", what's the specific question you have?