A Å×ÀÌºí¿¡´Â ID °íÀ¯°ªÀ¸·Î µ¥ÀÌÅÍ°¡ ½×ÀÌ°í ÀÖ½À´Ï´Ù.
ex)
ID | title | date
1 , °íÆã, 2018-07-11
2 , Æã°í, 2018-07-11
B Å×ÀÌºí¿¡´Â A.ID °ªÀ» ÂüÁ¶ÇÏ¿© ½×ÀÌ´Â µ¥ÀÌÅÍ°¡ ÀÖ½À´Ï´Ù.
ex)
ID | post_id | meta_key | meta_value
1 , 1, status, wait
2 , 1, email, mail@te31.com
3 , 2, status, ok
4 , 2, email, supportl@te31.com
ÀÌ·±±¸Á¶·Î µ¥ÀÌÅÍ°¡ ½×ÀÔ´Ï´Ù.
À̸¦ Çѹø¿¡ °¡Á®¿À°í ½Í½À´Ï´Ù.
A.ID,
A.title,
B.meta_value as status ( B.meta_key °¡ status ÀÌ¸é¼ B.meta_value °¡ wait ÀÎ °æ¿ì),
B.meta_value as email ( B.meta_key °¡ email ÀÎ °æ¿ì)
°£´ÜÇÑ Äõ¸®¸¸ ½è´õ´Ï.. ¸Ó¸®°¡ ¾Èµ¹¾Æ°¡³×¿ë ¤Ð¤Ð¤Ð¤Ð¤Ð¤Ð¤Ð
Áú¹® | 1682¸íÀÌ Àоú¾î¿ä. 3.128.79.88