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
3748 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

What is the purpose of mysql database?

917

Can I use mariadb instead of mysql?

913

What is definer in mysql trigger?

907

What is the difference between a heap table and temporary table?

938

What are queries used for?

946

How would you get the current date in mysql?

1093

what is database white box testing? : Mysql dba

990

What are mysql queries?

915

What is mysqli_select_db?

960

What is blob and text in mysql?

1166

What are the column comparisons operators?

1232

Can we create table in stored procedure?

952

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4655

What is a heap table?

951

How to include numeric values in sql statements?

998