select t1.value1, t1.value2, t2.valuea, t3.valuexx, t3.valueyy
from table1 as t1
join table2 as t2 on t2.id1 = t1.id1
join table3 as t3 on t3.id1 = t1.id1
where t1.stamp > XXX
order by t1.stampint8_t a = 4, b = 7, c = 6;
int32_t x = (c << 16) | (b << 8) | a;
// извлекаем:
a = (x & 0x000000FF);
b = (x & 0x0000FF00) >> 8;
c = (x & 0x00FF0000) >> 16;
struct BitField{
union{
int value;
struct{
int a:8;
int b:8;
int c:16;
};
};
};
BitField MyBits;
MyBits.a = 4; //fill the internal bit structure
MyBits.b = 7;
MyBits.c = 5;
cout << MyBits.value; //print the full int representation