使用SELECT Query从两个表中获取结果

Question

I have 2 MySQL tables:

I store the admin_vat_id in the Fac__Article table which is actually a reference to the id of the Fac__Admin_vat:

What I'm trying to do

I want to get all Fac__Article table's entries, but at the admin_vat_id column, where it normally would display the integer value, I want to display the float value of the column rate of the table Fac__Admin_vat.

I guess I have to use the select and union keyword, but I don't know how to implement this select query. Please guide me with knowledge in solving this problem.

Answer 1

All you need is a simple LEFT JOIN:

SELECT 
    fa.id,
    fav.rate,
    fa.article_number,
    fa.name,
    fa.description,
    fa.unit,
    fa.price,
    fa.stock,
    fa.stock_warning,
    fa.visible
FROM `fac_article` fa
LEFT JOIN `fac_admin_vat` fav
    ON fa.admin_vat_id = fav.id

SQL Fiddle