SELECT invoiceNumber FROM invoices i INNER JOIN articles a ON i.articleId=

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.

Question Posted / frank

1 Answers
3694 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How do I edit a database in mysql workbench?

873

How set mysql root password?

888

What is “i_am_a_dump” flag in mysql?

1012

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?

1865

Is mysql relational?

877

Can mysql store files?

889

What is root password?

870

Is mysql still popular?

884

Is mysql free for enterprise?

864

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2074

What is sqlyog?

997

What is limit in mysql?

837

What is delimiter in mysql stored procedure?

885

What is a data directory?

890

What is difference between mysql and mariadb?

1050