Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Join Fron Tables In 2 Data Bases

forums › forums › SQLyog › Using SQLyog › Join Fron Tables In 2 Data Bases

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • January 21, 2007 at 2:12 pm #10142
      ronny
      Member

      I have 2 data bases on 2 distinct servers from which I need to perform a query with a join on those tbles.

      I am using SQLyog. Each separate connection works fine.

      1) How can I define the other data base connection when staying on a SQLyog connection on DB1?

      2) What is the syntax of the query?

      Many thanks, Ronny

    • January 22, 2007 at 5:19 am #23280
      peterlaursen
      Participant

      You cannot join from distinct servers.  SQL does not allow for that!

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.