Uploaded image for project: 'Music'
  1. Music
  2. MUSIC-379

Error with the way tables are obtained

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Low Low
    • El Alto Release
    • None
    • mdbc
    • None

      The following SQL operation will fail in the current implementation:

      INSERT INTO Customers (CustomerName, Country) SELECT SupplierName, Country FROM Suppliers WHERE Country='Germany'
      

      In the current implementation all inner SQL statements will fail. Other examples would be a select inside an update.

            bptschaen bptschaen
            esaurez esaurez
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: