For the database from the previous question, please give an
SQL query which returns the invoice number of all invoices
which contain the article with the number ?1234?. The query
should be able to run under a MySQL 4.0 database.
Answer Posted / frank
SELECT invoiceNumber FROM invoices i INNER JOIN articles a
ON i.articleId=a.articleId WHERE article LIKE '%1234%';
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to validate email addresses in mysql?
What is default schema in mysql?
What are the disadvantages of mysql?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
How to update a root password.
How set mysql root password?
Can we rollback truncate in mysql?
What are all the Common SQL Function?
What is 'mysqld'?
How do I show all mysql databases?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
How do I select a table in mysql?
Does adding an index lock a table?
What does innodb stand for?